package cn.kxm.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import cn.kxm.pojo.SellOrderBill;
import cn.kxm.pojo.SellOrderBillDetail;

public interface SellOrderBillMapper {
   public List<Map<String, Object>> getSellOrderBills(@Param("code") String code,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("customName") String customName,@Param("dangqianye") Integer pageNo,@Param("size") Integer pageSize);
   public int getSellOrderBillCount(@Param("code") String code,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("customName") String customName);
   public Map<String, Object> getSellOrderBillByCode(@Param("code") String code);
   public List<Map<String, Object>> getfindPartsBySellCode(@Param("sellcode") String sellcode);
   public int addSellOrderBill(@Param("s")SellOrderBill sellOrderBill);
   public int addSellOrderBillDetail(@Param("sd")SellOrderBillDetail sellOrderBillDetail);
   public int updateSellOrderBill(@Param("s")SellOrderBill sellOrderBill);
   public int updateSellOrderBillDetail(@Param("sd")SellOrderBillDetail sellOrderBillDetail);
   public List<SellOrderBillDetail> getSellOrderBillDetailListByBillCode(@Param("billCode")String billCode);
   public int delSellOrderBill(@Param("code") String code);
   public int delSellOrderBillDetail(@Param("billCode")String billCode);
   public List<Map<String, Object>> getOfferPriceBills(@Param("code") String code,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("customName") String customName,@Param("dangqianye") Integer pageNo,@Param("size") Integer pageSize);
   public int getOfferPriceBillsCount(@Param("code") String code,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("customName") String customName);
   public int updateAuditing(@Param("code") String code);
   public int updateUnaudited(@Param("code") String code);
   public List<Map<String, Object>> getSellOrderBillList(@Param("code") String code,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("customName") String customName);
}
